# -*- coding:utf-8 -*-
from dao.MySqlDAL import MySqlDAL
import json
__author__ = 'shudongma.msd(风骐)'

s = MySqlDAL()

res = s.get_dimensions_rows("select symbol,date,stock_group from tb_cube_info where date > '2015-10-08' and date < '2016-02-23'")

for row in res:
    sg = json.loads(row['stock_group'])
    if type(sg).__name__ != 'list':
        print type(sg),row['symbol'],row['date'],sg